home *** CD-ROM | disk | FTP | other *** search
- DATETOTEXT
- Converts a date to text from the supplied serial number and format.
-
- Format: DATETOTEXT (serial-number {,format-number})
-
- Arguments:
- ΓÇó serial-number: The number of days before or after 1 January, 1904.
- ΓÇó format-number: Optional. A number in the range 0 to 4:
- 0 returns 22/12/90 (the preset format)
- 1 returns 22 Dec, 1990
- 2 returns 22 December, 1990
- 3 returns Sat, 22 Dec, 1990
- 4 returns Saturday, 22 December, 1990
-
- Example:
- DATETOTEXT (31990, 1) returns 2 Aug, 1991.
- Shows that the day represented by the serial number 31990 is 2 Aug, 1991.